find the all column with schema for any table in sql server

Question

Shankar M · Answer

Hi Varun,Alternatively you can try,SP_HELP EMP in SQL Serverand Here EMP is the table nameThanks,Shankar

Anonymous User · Answer

Hi Varun,
You can try this to find all column with schema for any table in sql server.
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’table_name’

forum

find the all column with schema for any table in sql server

Varun Agrawal

Can you answer this question?

2 Answers

Liked By